SELECT Id FROM new_searchtable
where (water_body like 'Newfound%' and water_body_type ='Lake') and type ='M'
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Newfound Lake NH Multi Family Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:In-town Bristol: New Englander with 5 bedrooms, currently being used as a 2 family. Level corner lot, conveniently located within walking distance of restaurants, local shops, schools. Main level is reminiscent of the older homes, with the kitchen leading into the dining room on one side and the living room on the other. Three bedrooms, full bath and large laundry room. There are 2 wood stoves to keep you warm and cozy on those chilly nights. Upstairs, via a separate entrance, there are2 bedrooms, a 3/4 bath, kitchen and a living room. There is also a one-car oversized garage and a large storage area. There are TWO covered porches, as an added bonus! Recent updates include flooring, appliances, interior wall finishes, and a renovated bathroom upstairs.